Originally published at Kyle Boddy. You can comment here or there.

I recently wrote a mass geolocation script in PHP since Google seems to be taking down all the websites that offer this vital service. Right now it:

• Checks a table for records without lat/long coordinates
• Sends those records' addresses to Google's geolocation API
• Updates your records ( Read more... )

Originally published at Kyle Boddy. You can comment here or there.


( Read more... )

Originally published at Kyle Boddy. You can comment here or there.

I was going to type up a giant thing about why the newest XAMPP doesn't work well with MySQL because it's packaged with a beta PHP version and stuff... but I honestly don't want to elaborate. Just know that I wasted 4-6 hours of my life and about an hour of Site5's support because of ( Read more... )

Originally published at Kyle Boddy. You can comment here or there.

I've launched yet another half-complete web application relating to baseball sabermetrics! ML Splits is a database of minor league baseball players (batters only for now) that shows their "splits" (performance against LHP and RHP) as well as park effects and major league ( Read more... )

Originally published at Kyle Boddy. You can comment here or there.

I've started to use Springloops RC2 for my version control efforts, which is really awesome. They support SVN and git (no Mercurial yet), have a great interface with easy deployments to multiple servers so you can split them up into production/staging/development, a solid ticketing ( Read more... )

Originally published at Kyle Boddy. You can comment here or there.


( Read more... )

Originally published at Kyle Boddy. You can comment here or there.

Title says it all, for the most part:

http://injurydb.drivelinebaseball.com

Corrections to release point data were implemented with the generous help of Max Marchi of The Hardball Times. Go check them out! Regression sets are coming...

Originally published at Kyle Boddy. You can comment here or there.

As detailed in this Stack Overflow request, I had the need to convert an existing database of users/passwords (stored in plaintext) to our new authentication library driven by CI and TankAuth. User jondavidjohn got me on the right track, and here's the code I ended up writing to ( Read more... )

Originally published at Kyle Boddy. You can comment here or there.

Recently I needed to call trim() for multiple variables in an array in my CodeIgniter application, but had issues with calling the custom function using array_walk() to do so. A bit of Googling and experimentation led me to this answer:

function stuff ( Read more... )

Originally published at Kyle Boddy. You can comment here or there.

This isn't pretty, but I needed to write code that would merge two arrays of differing sizes. One contained injury information for 1400 players with an overlapping field of elias_id with an array of 900 players of PITCHf/x data. Simply put, I needed to insert two values from the ( Read more... )